<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
 "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
	<title>symfony_tp</title>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
	<meta name="date" content="Sat, 29 Apr 2017 17:42:17 +0800">
	<meta name="generator" content="MySQL-Front 5.3  (Build 4.243)">
	<style type="text/css"><!--
		body {font-family: Arial,Helvetica,sans-serif; font-size: 12px;}
		h1 {font-size: 18px; text-decoration: bold;}
		h2 {font-size: 16px; text-decoration: bold;}
		h3 {font-size: 14px; text-decoration: bold;}
		th,
		td {font-size: 12px; border-color: #000000; border-style: solid; border-width: 1px; padding: 1px; font-weight: normal;}
		code {font-size: 12px;}
		.TableObject {border-collapse: collapse; border-color: #000000; font-family: Microsoft Sans Serif}
		.TableData {border-collapse: collapse; border-color: #000000; font-family: Microsoft Sans Serif}
		.TableHeader {border-color: #000000; text-decoration: bold; background-color: #e0e0e0;}
		.StructureHeader {padding-left: 5px; text-align: left; border-color: #000000; text-decoration: bold;}
		.Structure {text-align: left; border-color: #aaaaaa;}
		.odd {}
		.even {}
		.DataHeader {padding-left: 5px; text-align: left; border-color: #000000; background-color: #e0e0e0;}
		.Null {color: #999999;}
		.PrimaryKey {font-weight: bold;}
		.RightAlign {text-align: right;}
	--></style>
</head>
<body>
<h1 class="DatabaseTitle">数据库: symfony_tp</h1>
<h2>表格: note</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="note" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>id</td><td>unique</td><td></td></tr>
	<tr class="Structure"><td >IDX_CFBDFA14217BBB47</td><td>person_id</td><td>&nbsp;</td><td></td></tr>
	<tr class="Structure"><td >IDX_CFBDFA143779744C</td><td>linked_person_id</td><td>&nbsp;</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="note" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">id</td><td>int(11)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>&nbsp;</td>	</tr>
	<tr class="Structure"><td>person_id</td><td>int(11)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td>	</tr>
	<tr class="Structure"><td>linked_person_id</td><td>int(11)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>&nbsp;</td>	</tr>
	<tr class="Structure"><td>entry_date</td><td>datetime</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>&nbsp;</td>	</tr>
	<tr class="Structure"><td>author_name</td><td>varchar(45)</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td>	</tr>
	<tr class="Structure"><td>author_email</td><td>varchar(45)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>&nbsp;</td>	</tr>
	<tr class="Structure"><td>author_phone</td><td>varchar(45)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>&nbsp;</td>	</tr>
	<tr class="Structure"><td>source_date</td><td>datetime</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td>	</tr>
	<tr class="Structure"><td>author_made_contact</td><td>tinyint(1)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>联系作者</td>	</tr>
	<tr class="Structure"><td>status</td><td>varchar(45)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>状态</td>	</tr>
	<tr class="Structure"><td>email_of_found_person</td><td>varchar(45)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>发现人的邮箱</td>	</tr>
	<tr class="Structure"><td>phone_of_found_person</td><td>varchar(45)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>发现人的电话</td>	</tr>
	<tr class="Structure"><td>last_known_location</td><td>varchar(45)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>最后一个已知位置</td>	</tr>
	<tr class="Structure"><td>text</td><td>tinytext</td><td>否</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td>	</tr>
	<tr class="Structure"><td>photo_url</td><td>varchar(45)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>&nbsp;</td>	</tr>
</table><br>
<h3>约束:</h3>
<table border="0" cellspacing="0" summary="note" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th></tr>
	<tr><th>FK_CFBDFA14217BBB47</th><td>person_id -&gt; person.id</td><td></td></tr>
	<tr><th>FK_CFBDFA143779744C</th><td>linked_person_id -&gt; person.id</td><td></td></tr>
</table><br>
<h3>数据:</h3>
<table border="0" cellspacing="0" summary="note" class="TableData">
	<tr class="TableHeader"><th class="DataHeader PrimaryKey">id</th><th class="DataHeader">person_id</th><th class="DataHeader">linked_person_id</th><th class="DataHeader">entry_date</th><th class="DataHeader">author_name</th><th class="DataHeader">author_email</th><th class="DataHeader">author_phone</th><th class="DataHeader">source_date</th><th class="DataHeader">author_made_contact</th><th class="DataHeader">status</th><th class="DataHeader">email_of_found_person</th><th class="DataHeader">phone_of_found_person</th><th class="DataHeader">last_known_location</th><th class="DataHeader">text</th><th class="DataHeader">photo_url</th></tr>
</table><br style="page-break-after: always">
<h2>表格: person</h2>
<h3>索引:</h3>
<table border="0" cellspacing="0" summary="person" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td  class="PrimaryKey">主索引</td><td>id</td><td>unique</td><td></td></tr>
</table><br>
<h3>字段:</h3>
<table border="0" cellspacing="0" summary="person" class="TableObject">
	<tr class="TableHeader StructureHeader"><th>名称</th><th>类型</th><th>空</th><th>默认值</th><th>属性</th><th>备注</th></tr>
	<tr class="Structure"><td class="PrimaryKey">id</td><td>int(11)</td><td>否</td><td>&lt;auto_increment&gt;</td><td>&nbsp;</td><td>&nbsp;</td>	</tr>
	<tr class="Structure"><td>entry_date</td><td>datetime</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>进入日期</td>	</tr>
	<tr class="Structure"><td>expiry_date</td><td>datetime</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>到期日</td>	</tr>
	<tr class="Structure"><td>author_name</td><td>varchar(45)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>作者姓名</td>	</tr>
	<tr class="Structure"><td>author_email</td><td>varchar(45)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>作者邮箱</td>	</tr>
	<tr class="Structure"><td>author_phone</td><td>varchar(45)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>作者电话</td>	</tr>
	<tr class="Structure"><td>source_name</td><td>varchar(45)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>源名称</td>	</tr>
	<tr class="Structure"><td>source_date</td><td>datetime</td><td>否</td><td>0000-00-00 00:00:00</td><td>&nbsp;</td><td>源日期</td>	</tr>
	<tr class="Structure"><td>source_url</td><td>varchar(100)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>源URL</td>	</tr>
	<tr class="Structure"><td>full_name</td><td>varchar(45)</td><td>否</td><td></td><td>&nbsp;</td><td>全名</td>	</tr>
	<tr class="Structure"><td>given_name</td><td>varchar(20)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>给定名称</td>	</tr>
	<tr class="Structure"><td>family_name</td><td>varchar(20)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>姓</td>	</tr>
	<tr class="Structure"><td>alternate_names</td><td>varchar(45)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>别名</td>	</tr>
	<tr class="Structure"><td>description</td><td>longtext</td><td>是</td><td>&nbsp;</td><td>&nbsp;</td><td>描述</td>	</tr>
	<tr class="Structure"><td>sex</td><td>varchar(10)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>性别</td>	</tr>
	<tr class="Structure"><td>date_of_birth</td><td>date</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>出生日期</td>	</tr>
	<tr class="Structure"><td>age</td><td>smallint(6)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>年龄</td>	</tr>
	<tr class="Structure"><td>home_street</td><td>varchar(45)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>家庭街道</td>	</tr>
	<tr class="Structure"><td>home_neighborhood</td><td>varchar(45)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>家居社区</td>	</tr>
	<tr class="Structure"><td>home_city</td><td>varchar(45)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>家居城市</td>	</tr>
	<tr class="Structure"><td>home_state</td><td>varchar(45)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>家庭状态</td>	</tr>
	<tr class="Structure"><td>home_postal_code</td><td>varchar(45)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>邮政编码</td>	</tr>
	<tr class="Structure"><td>home_country</td><td>varchar(45)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>祖国</td>	</tr>
	<tr class="Structure"><td>photo_url</td><td>varchar(100)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>照片URL</td>	</tr>
	<tr class="Structure"><td>profile_urls</td><td>varchar(100)</td><td>是</td><td>&lt;空&gt;</td><td>&nbsp;</td><td>个人资料URL</td>	</tr>
</table><br>
<h3>数据:</h3>
<table border="0" cellspacing="0" summary="person" class="TableData">
	<tr class="TableHeader"><th class="DataHeader PrimaryKey">id</th><th class="DataHeader">entry_date</th><th class="DataHeader">expiry_date</th><th class="DataHeader">author_name</th><th class="DataHeader">author_email</th><th class="DataHeader">author_phone</th><th class="DataHeader">source_name</th><th class="DataHeader">source_date</th><th class="DataHeader">source_url</th><th class="DataHeader">full_name</th><th class="DataHeader">given_name</th><th class="DataHeader">family_name</th><th class="DataHeader">alternate_names</th><th class="DataHeader">description</th><th class="DataHeader">sex</th><th class="DataHeader">date_of_birth</th><th class="DataHeader">age</th><th class="DataHeader">home_street</th><th class="DataHeader">home_neighborhood</th><th class="DataHeader">home_city</th><th class="DataHeader">home_state</th><th class="DataHeader">home_postal_code</th><th class="DataHeader">home_country</th><th class="DataHeader">photo_url</th><th class="DataHeader">profile_urls</th></tr>
</table><br style="page-break-after: always">
</body>
</html>
